[dbo].[BAEOrderProductCrossSellLookupUpdate]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderProductCrossSellLookupUpdate

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderProductID	int	4
@OrderProductCrossSellID	int	4

SQL Script

create procedure [dbo].[BAEOrderProductCrossSellLookupUpdate] @OrderProductID as
int,
    @OrderProductCrossSellID AS int
AS
    UPDATE OrderProductCrossSellLookup
    SET
    OrderProductID = @OrderProductID,
    CrossSellOrderProductID = @OrderProductCrossSellID

    WHERE OrderProductID = @OrderProductID AND
    CrossSellOrderProductID = @OrderProductCrossSellID;

GO

Uses

[dbo].[OrderProductCrossSellLookup]
dbo